<?php
	session_start();

	if( $_POST['City'] == "Any" || $_POST['City'] == "")
	{
		$strKey = "";
	}
	else
	{
		$strKey = $_POST['City'];
	}
	include("mysql_connect.php");
		
	$strSqlCommand = "SELECT Neighborhood
						FROM ResidentialProperty tbRP
						LEFT JOIN Listing  tbLT			ON tbRP.Listing_idListing = tbLT.idListing
						LEFT JOIN StreetAddress  tbSA	ON tbLT.StreetAddress_idStreetAddress = tbSA.idStreetAddress
						WHERE City LIKE '%".$strKey."%'
						GROUP BY Neighborhood";
		
	//echo $strSqlCommand;
		
	$result = mysql_query($strSqlCommand);
	
	echo '<option selected="selected">Any</option>';
//	echo 'Any<br/>';
	//echo $strSqlCommand;
	while($rowAddress = @mysql_fetch_array($result))	
	{// URL, Price,idListing
		echo '<option>'.$rowAddress['Neighborhood'].'</option>';
//		echo $rowAddress['ZipBorough'].'<br/>';
	}
	
?>